package com.pks.datacenter.entity.basic;

import lombok.Data;
import lombok.EqualsAndHashCode;

import com.pks.util.coder.database.DBField;
import com.pks.util.coder.database.DBQuery;
import com.pks.util.coder.database.DBTable;
import com.pks.web.mybatis.entity.BasicEntity;

@Data
@EqualsAndHashCode(callSuper = true)
@DBTable(tags = "数据库")
public class DbSource extends BasicEntity {

	private static final long serialVersionUID = 4375474904693083163L;
	
	@DBQuery(value = {"=" , "like"})
	@DBField(comment = "数据库名称" , length = 100 , nullable = false)
	private String name ; 			
	
	@DBQuery
	@DBField(comment = "数据库类型 1-MYSQL  2-SQLSERVER 3-ORACLE" , length = 4 , nullable = false)
	private Integer db_type;
	
	@DBQuery(value = {"=" , "like"})
	@DBField(comment = "数据库IP" , length = 100 , nullable = false)
	private String db_ip;
	
	@DBField(comment = "数据库端口号" , length = 11 , nullable = false)
	private Integer db_port;
	
	@DBQuery(value = {"=" , "like"})
	@DBField(comment = "数据库库名" , length = 100 , nullable = false)
	private String db_name;

	@DBQuery(value = {"=" , "like"})
	@DBField(comment = "数据库账号" , length = 100 , nullable = false)
	private String db_account;
	
	@DBField(comment = "数据库密码" , length = 100, nullable = false)
	private String db_password;
	
	private Integer show_state;
	
}
